CREATE VIEW [dbo].[vSoaGroupSummaryMT]
WITH SCHEMABINDING
AS
    SELECT  'MT-' + [Member_Types].[MEMBER_TYPE] AS [GroupId],
            'Public' AS [ParentEntityTypeName],
            'Public Groups' AS [ParentEntityId],
            'MT' AS [GroupClassId],
            [Member_Types].[DESCRIPTION] AS [Name],
            CAST([Member_Types].[DESCRIPTION] AS VARCHAR(6000)) AS [Description],
            [Member_Types].[MEMBER_RECORD] AS [IsMemberGroup]
      FROM  [dbo].[Member_Types]


GO
CREATE UNIQUE CLUSTERED INDEX [PK_vSoaGroupSummaryMT] ON [dbo].[vSoaGroupSummaryMT] ([GroupId]) ON [PRIMARY]
GO